﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace SqlImEx.Sql
{
    public class TableSchema
    {
        public string Schema { get; set; }
        public string Table { get; set; }
    }
    public class IdentityColumn
    {
        public string Table { get; set; }
        public string Schema { get; set; }
        public string Column { get; set; }
        public long SeedValue { get; set; }
        public long IncrementValue { get; set; }
        public bool NotForReplication { get; set; }
    }
    public class ForeignKeyConstraint
    {
        public override string ToString()
        {
            return FKConstraintName;
        }
        public ForeignKeyConstraint()
        {
            _Columns = new List<ForeignKeyConstraintColumns>();
        }
        public string FKConstraintName { get; set; }
        public string FKTableName { get; set; }
        public string FKSchemaName { get; set; }
        public string RefTableName { get; set; }
        public string RefSchemaName { get; set; }

        public List<ForeignKeyConstraintColumns> _Columns { get; set; }
    }
    public class ForeignKeyConstraintColumns
    {
        public string FKColumnName { get; set; }
        public int FKOrdinal { get; set; }
        public string RefConstraintName { get; set; }
        public string RefColumnName { get; set; }
        public int RefOrdinal { get; set; }
    }
}
